﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace Syx.Webapi.AppCode.Entities {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "EX_USER", DisableSyncStructure = true)]
	public partial class EXUSER {

		[JsonProperty, Column(Name = "USER_ID", IsPrimary = true)]
		public uint USERID { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? BIRTHDAY { get; set; }

		/// <summary>
		/// 联系方式
		/// </summary>
		[JsonProperty, Column(Name = "CONTACT_WAY")]
		public uint? CONTACTWAY { get; set; }

		[JsonProperty, Column(Name = "CREATE_DATE", DbType = "DATE(7)")]
		public DateTime? CREATEDATE { get; set; }

		[JsonProperty, Column(Name = "CREATE_USER")]
		public uint? CREATEUSER { get; set; }

		[JsonProperty, Column(Name = "DEPARTMENT_ID")]
		public uint? DEPARTMENTID { get; set; }

		[JsonProperty, Column(Name = "DIAPLAY_NO")]
		public uint? DIAPLAYNO { get; set; }

		/// <summary>
		/// 邮箱
		/// </summary>
		[JsonProperty, Column(Name = "E_MAIL", DbType = "VARCHAR2(20 BYTE)")]
		public string EMAIL { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string EDUCATION { get; set; }

		/// <summary>
		/// 创建时间
		/// </summary>
		[JsonProperty, Column(Name = "FOUND_DATE", DbType = "DATE(7)")]
		public DateTime? FOUNDDATE { get; set; }

		/// <summary>
		/// 上级
		/// </summary>
		[JsonProperty, Column(Name = "HIGHER_LEVEL", DbType = "VARCHAR2(20 BYTE)")]
		public string HIGHERLEVEL { get; set; }

		/// <summary>
		/// Y--启用；N--删除
		/// </summary>
		[JsonProperty, Column(Name = "IS_USE", DbType = "VARCHAR2(2 BYTE)")]
		public string ISUSE { get; set; }

		[JsonProperty, Column(Name = "LOGIN_PASSWORD", DbType = "VARCHAR2(200 BYTE)")]
		public string LOGINPASSWORD { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string NATION { get; set; }

		/// <summary>
		/// 职位
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string POSITION { get; set; }

		/// <summary>
		/// M---男；F---女
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(2 BYTE)")]
		public string SEX { get; set; }

		/// <summary>
		/// 员工id
		/// </summary>
		[JsonProperty, Column(Name = "STAFF_ID")]
		public uint? STAFFID { get; set; }

		/// <summary>
		/// 级别 1-普通员工 2-低层管理 3-中层管理 4-高层管理 5-集团经理
		/// </summary>
		[JsonProperty, Column(Name = "STAFF_RANK")]
		public uint? STAFFRANK { get; set; }

		/// <summary>
		/// D-离职；C-在职；E-试用
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(5 BYTE)")]
		public string STATUS { get; set; }

		[JsonProperty, Column(Name = "USER_ACCOUNT", DbType = "VARCHAR2(50 BYTE)")]
		public string USERACCOUNT { get; set; }

		[JsonProperty, Column(Name = "USER_NAME", DbType = "VARCHAR2(50 BYTE)", IsNullable = false)]
		public string USERNAME { get; set; }

	}

}
